SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516152 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516152 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473041,177819,678730,195845,975124,308299,166630,811906,685130,685489,527913,954533,804394,208473,657774,850512,402450,122603,255040,184503,509415,863039,121134,1048502,407661,812898,34866,569282,986668,478428,53000,502934,569890,641963,58224,436865,463449,758364,1004791,1000626,399120,785604,646398,999192,187427,339776,427640,779104,549750,1022600,863926,203365,750979,1015343,502869,483069,678369,525858,367100,334649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]