SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002547s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505319 LIMIT 1 [ RunTime:0.001932s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505319 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363388,478424,654109,454903,728822,888408,646427,626985,1017476,550394,94022,680036,542935,818029,57274,200233,610981,226968,2509,112726,921826,58164,366257,198765,908776,1014314,420613,280176,450559,227132,176035,899871,360073,469991,707048,381547,402800,877366,209797,926390,658406,854238,461793,141197,736414,1003830,202461,560542,216940,11204,816851,925834,778950,945777,833147,4197,798706,522678,690308,674028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001061s ]