SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 388335 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388335 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98089,2633,611446,565334,100957,140045,758623,68234,410960,740327,247596,460391,425137,76113,341481,588756,288085,1014088,148149,175035,277577,37563,717193,9944,389436,850691,547506,460855,497148,928058,174421,1020332,780936,665712,366118,1027394,833671,310903,198305,756169,753747,211854,471161,528319,304762,473324,324645,23061,830017,1035848,680888,723285,738911,137394,1036291,444115,38875,1005186,908546,277149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]