SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012647 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012647 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114328,1024074,81160,223265,572014,527846,118213,888598,990096,301991,140441,234207,763734,826523,991109,803938,388894,821674,78879,290969,675871,189460,632604,719136,330516,398708,27734,383610,847193,235641,1002040,944484,371640,709853,77247,718793,38255,293754,733043,377793,573378,5281,535929,332137,1011170,746919,533059,348779,236039,221736,137213,65301,292729,96746,1010002,716318,891810,322831,309861,628236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012647 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012647 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]