SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465939 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465939 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328634,411285,647804,469158,754933,335800,417192,930826,891939,47806,43107,646198,623219,150325,163991,863649,496224,173295,93456,296331,685178,1039066,605867,16072,986436,71175,277162,804537,731768,7191,402657,716303,524207,469231,619799,259081,488567,1003017,526788,465508,790001,785837,442366,369545,970614,770887,497590,614756,919989,15096,853950,170050,581396,437085,759007,569086,649021,730024,1003104,646465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]