SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488018 LIMIT 1 [ RunTime:0.003208s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488018 [ RunTime:0.004644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500193,763970,552853,338645,998246,134908,957405,174340,540649,307570,595800,28399,1027454,19767,621194,804265,900760,94350,69486,143373,575551,75391,831069,740042,427484,1008919,840042,894620,597892,560623,882017,913279,859088,244063,133145,1024745,391862,497552,646584,474943,988740,793661,317038,658837,1457,88528,1011709,313741,938988,160914,882959,313970,666483,838800,287295,397137,604696,1039410,1025286,715807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]