SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584420 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584420 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725554,302449,551608,731893,982203,893285,368713,656148,808859,1028933,127381,691132,166481,854033,637945,35225,257623,515697,745570,964460,174623,1022438,559691,942227,373631,412855,702069,737404,79536,472332,984957,581245,316060,953863,378990,553725,371379,11042,237123,831554,273993,269005,371067,580141,972885,781760,310882,511748,247522,431809,239743,458546,157926,586962,895473,237722,58355,279343,499061,337484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000725s ]