SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311820 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311820 [ RunTime:0.002618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540392,1030871,586205,141731,317635,1038133,630281,604840,384988,35267,1043895,997232,559077,21690,736996,903163,265941,945502,750140,437470,33501,719482,233548,352970,318449,583123,306135,56991,435955,849573,241118,1023359,1014293,941932,847513,560542,609990,93958,366598,600713,1037005,536285,154686,601877,153736,789758,866124,491865,866780,189736,910133,935689,518120,947696,215587,933655,519818,54208,739865,380655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]