SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419642 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419642 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691661,355292,719118,658266,582961,1014334,1036915,150000,226618,96413,843055,823429,338857,348893,676914,509107,1032018,565385,359776,275150,528620,516779,1048215,736196,305765,792235,662560,1000586,549855,386104,32683,38873,22684,399365,731313,708832,74421,678053,60821,602026,528013,376690,829234,824456,410944,627039,474030,100159,45122,495960,958061,760277,392658,960995,895214,394375,19583,548246,254436,797000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]