SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53656 LIMIT 1 [ RunTime:0.001678s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53656 [ RunTime:0.003761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908332,584131,845651,1041331,359566,488249,603886,659838,415940,32319,382105,271491,1005383,16488,237708,537269,672793,380435,464116,1017976,509547,741164,1044313,607854,122908,442391,574978,738228,181085,955200,229408,319527,173729,877529,486660,332051,760680,458348,507607,905382,310657,709491,633609,859795,541338,994750,1011173,38378,431657,842019,171966,61782,377247,668420,282063,383083,614757,453501,920583,190416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]