SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386200 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386200 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134972,788117,1014856,410678,1011330,1038528,1043505,235834,187940,443521,299662,470016,395525,74162,806754,82102,337395,662176,583330,68123,511762,837898,1010358,603674,964588,310557,271848,498035,759794,681724,88490,257693,11512,959327,497253,841377,974580,460475,567992,671596,940948,859965,70204,819297,382936,233990,869141,597823,509618,47609,375412,230178,921456,724083,822100,418918,369555,243412,1013061,299281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]