SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400713 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400713 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585472,184269,680397,608321,264858,72786,325996,779438,344539,657449,644275,647983,278411,442544,538092,392725,382467,604169,612385,790780,545142,331585,21590,786274,780382,689584,251838,699848,92518,680139,839920,695263,580933,288549,731748,697572,180515,708369,1044320,227149,855682,1013311,273709,609139,621466,398517,284053,360048,320060,1008945,226631,894313,1017637,219055,683769,271913,385474,830673,122982,466710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001860s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]