SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 366801 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 366801 [ RunTime:0.003238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845523,717704,882595,823600,504533,341043,104023,221841,344008,306379,148674,707116,846045,838627,672236,7217,468583,404171,634637,546886,671022,249373,809458,693754,779081,741667,79902,908963,40204,663769,1032444,849334,463133,95774,203417,917785,293261,371989,1018014,81244,2187,942422,901940,271063,720432,539149,783102,440248,223485,125681,253307,325967,552389,1009591,674500,25169,821196,320572,347216,459817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 366801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 366801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]