SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537813 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537813 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938158,857454,562914,443549,656495,652937,864618,534338,46572,865136,556103,902650,368691,964670,983477,407743,532930,321515,503168,357294,862154,418750,111909,259745,107520,297129,618969,52063,174192,751916,907876,499081,751232,532723,7284,131840,103886,487726,144791,85805,121710,497859,392745,351787,970736,252406,86143,777283,406308,979798,729172,269962,180044,345534,422293,266524,172547,945497,995263,638572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]