SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485201 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485201 [ RunTime:0.004964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423173,762373,388858,13823,543795,322497,928317,984456,1041484,847657,1036390,445740,613879,1038013,285992,748535,36247,151762,413985,766197,174952,478548,209194,775107,102851,802629,882366,486754,836666,277169,1007942,778045,871673,870853,786025,599111,947058,128418,433254,728246,703159,601710,70395,104251,971756,930609,105002,708997,991655,90042,485690,467707,945503,126903,388305,294590,481773,777371,721538,660263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]