SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505116 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505116 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011623,1029503,874832,41665,250417,248861,987450,37380,931774,305366,542140,608482,601855,999215,876273,315634,211706,906681,165669,659823,645740,509039,751065,36477,840108,859766,1004474,259616,495827,80195,475083,67302,43735,405727,434752,169496,514469,1009584,768684,868936,24440,133841,543349,992977,493248,259345,467895,586117,492748,668810,429877,350272,702289,69225,277797,69098,1034216,895253,792471,393817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]