SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497653 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497653 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77882,62014,828987,311109,136949,298147,211468,150872,1010497,673790,982410,107082,55777,450175,427920,810848,8715,741761,553289,538820,260366,540089,761851,535670,918936,544107,175908,124091,277688,565361,318908,471144,490658,70963,653575,888037,455449,254186,748710,698816,90214,644764,529081,614765,430098,781866,137931,665158,785384,3289,599865,15929,494879,368955,601616,355194,820643,23161,541026,419185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]