SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036917 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036917 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801662,362286,247933,873172,545520,327254,945150,754032,9765,641481,763875,668539,65423,918834,138733,52563,276730,1014060,182508,737721,846797,964600,849528,493245,959597,1019882,197842,122621,876353,282765,627489,661120,108113,921041,820334,374762,385459,522936,340672,611462,448840,625776,797826,403749,107431,541925,490357,286707,633770,534580,971998,345335,592803,99066,759950,335938,829490,497066,23738,396220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]