SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311608 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311608 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136921,122623,253632,291591,889511,1015589,706130,1000141,539960,162515,662392,441501,239148,443853,869107,29042,141988,617090,814688,994601,683552,783612,319708,934851,975193,239704,255392,775901,735887,766340,993673,841087,646829,629954,646127,710833,381216,44671,540464,621864,928137,168132,107752,238139,417877,1000486,484865,108565,687623,154417,391096,832364,1037296,225759,468473,650096,412512,138383,539553,79745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]