SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006926s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687581 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687581 [ RunTime:0.001494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967187,959804,774453,92730,814872,735861,1001395,569306,981219,607060,858548,303475,26712,773587,725368,181197,1025313,943676,59856,732247,809983,1014081,234634,438303,121341,510806,524597,648725,425979,506216,184252,608728,745420,749969,95621,1008510,802923,11914,623401,1043780,768699,691920,119856,964620,715505,189668,594590,137547,836822,592150,598059,177546,695575,841046,197877,1010520,75518,1035595,447680,410870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000789s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]