SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419080 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419080 [ RunTime:0.002195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377201,453444,60560,133733,16399,399410,1047457,407917,115131,608962,503532,425197,304420,451016,918823,385930,558927,694974,317194,467712,310752,116713,316124,520803,234997,107269,168249,593932,838650,57370,976702,941098,815615,144500,266763,546772,155108,28926,470516,731994,446255,187200,682015,624230,709398,158522,212649,290162,424559,633996,203033,782230,386985,441605,583267,970940,76467,42879,457678,169254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]