SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4480 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4480 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302032,20381,759670,915567,768794,244480,267967,60478,57897,630751,311319,488934,786563,157791,726286,40024,352944,204674,1031367,341855,964583,59671,322276,509486,530481,566304,277062,189300,801212,829244,312412,259242,500831,214741,687844,720751,412276,664079,381278,88960,318362,15300,587704,369247,688348,927528,405705,555676,407079,542323,791888,1014151,492443,379544,3695,454262,465250,8407,321966,496691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]