SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534518 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534518 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458603,695810,920590,443370,727855,663128,725168,39205,827450,952266,536911,584747,489415,607994,106021,744675,652436,645982,931861,713131,689450,419921,910336,844829,420505,779349,569788,1012041,918972,989471,476849,194400,1984,83266,401754,105303,455099,49805,270140,814543,670269,1002721,1025415,761509,7771,366289,396837,912879,417399,591921,758657,852880,282762,593763,670299,733309,57263,372597,549973,556532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000377s ]