SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595780 LIMIT 1 [ RunTime:0.000537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595780 [ RunTime:0.005357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372484,698292,715389,1029471,180129,835208,82356,83157,731035,826436,149863,135459,84358,497848,146458,769985,321106,872582,790072,467415,618257,313016,195664,1031826,145273,993989,604,688577,204155,771290,530224,547192,509578,350673,783411,334914,870686,623617,1023088,453962,43198,793544,583516,675332,506073,622523,301290,437388,874161,1035987,464928,499579,804921,181599,1027709,447644,645001,903817,526725,938840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000930s ]