SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003494s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518975 LIMIT 1 [ RunTime:0.000664s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518975 [ RunTime:0.002882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203276,814389,112042,961620,355994,907859,386441,871725,272999,801756,38675,656001,1047411,463315,637945,944339,69214,492151,59829,974917,2863,123894,120704,138118,393604,434456,265239,678885,198441,394071,535699,399917,203841,9443,329966,94528,343596,156771,897653,923086,952984,256525,713597,131617,11481,249368,991745,231723,149381,95050,971588,984172,181728,574672,756800,153816,773295,578780,445067,1017501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]