SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514912 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514912 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907645,71916,533823,1014557,140083,686364,872137,476897,1021796,170957,516859,361068,67790,354218,570111,523774,178443,729002,939290,349796,44627,425209,735263,775245,331175,455222,956668,213446,660630,510314,66565,575299,944709,360561,264106,507161,117915,588782,909144,723316,910092,413423,78686,187833,659914,549602,443430,98398,558634,707457,472732,674745,740397,458842,1018931,920109,997489,627418,555394,710316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]