SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409341 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409341 [ RunTime:0.006757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297919,1033027,822904,58945,271944,487420,686329,919318,687170,227309,145637,151822,383857,467452,896848,822870,515889,202827,307115,102819,49358,368777,1031493,282296,819808,142149,335229,409610,87375,499522,28434,557444,762041,80425,1032269,169361,845094,39360,622979,288314,692679,386253,683642,662071,720599,100134,962756,395854,417695,925962,585222,525581,628843,1024332,765956,238330,297593,417691,483512,421971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]