SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 602012 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 602012 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904764,589865,859174,531537,859110,191892,291995,712218,324023,176958,278997,182679,982886,313523,799210,498537,825369,440418,212797,225322,550804,892239,85236,785711,360079,165686,173631,440366,596201,145760,105091,651644,676610,410704,584798,728801,12154,943275,839286,105999,467083,946614,416431,976209,793740,485626,218528,68982,59507,184256,60792,1003342,735867,300601,899096,218901,766676,52179,381477,880669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 602012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 602012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]