SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455650 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455650 [ RunTime:0.003004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457046,737464,597897,953485,733973,242003,505151,208079,353191,484929,471690,312082,591142,547744,977223,102624,525809,324907,640327,596325,850630,634037,604327,122475,962833,1019714,924744,276818,12828,771713,599048,675193,661664,1047449,897185,94345,23921,570712,252003,109703,920007,799623,249465,720282,741107,326884,564551,150112,722818,314444,965887,404377,908279,327986,189927,829319,106015,184171,619582,857300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]