SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480056 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480056 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551326,461977,150560,463531,189750,743960,524045,643254,464810,1000701,516452,1040685,431189,660721,46754,748421,278817,451129,135522,190445,172368,552200,601571,937032,465855,320842,45831,712816,790093,727126,512441,157210,491132,739971,698257,339089,46515,392514,750701,371562,533132,875905,535227,880216,985765,370338,849180,916125,698037,682698,496881,508884,38455,771270,47334,352370,239166,301666,440075,390272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000828s ]