SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587823 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587823 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744080,863770,1043948,734051,533080,331278,771778,566967,797037,35845,426138,1001880,166764,106889,916333,123813,1037822,712480,555325,304281,1029322,748768,48344,850458,832221,892143,292619,42089,150727,482698,51415,913113,43364,862383,365782,116227,887762,968844,171513,370178,61217,571427,185235,188683,139990,463127,129437,470895,562538,981042,363720,157337,822997,78210,691271,310514,679510,516726,1033218,273036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]