SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456509 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456509 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665072,222966,777171,786186,510452,995090,12951,871206,625968,413636,895250,851693,419142,531124,1031553,261202,1039260,211057,26510,196906,763995,721000,28327,9148,832,814066,857916,352498,701711,824503,179852,484365,27141,1033560,713314,832190,828610,32778,926331,1040622,841572,55993,168827,596878,93018,532145,985486,739143,169398,134152,386523,648244,420912,720434,772200,887772,926649,14207,762755,338154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]