SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003251 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003251 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53301,441285,1043347,925647,256381,204627,582361,524747,820409,396346,820059,57817,186289,520307,188163,207,767150,64523,292405,155483,176737,740002,851756,404315,724589,924914,378972,476421,880816,1006269,596543,277977,925350,280062,552644,820023,880670,505137,22109,622582,91312,488637,472980,141515,30030,143146,851306,720149,725286,521034,973923,385678,391351,551508,555844,142621,292380,525201,270794,255345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]