SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013439 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013439 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249312,542558,647272,272031,807824,871022,905434,707130,226315,88621,965329,849311,433186,999440,315489,869205,8737,647864,118360,1019474,427551,822073,100308,393460,907828,295017,638557,34203,218372,269757,902564,938262,189846,731378,1004451,836479,899834,817886,824294,340210,771664,706026,325327,440751,531108,618488,585957,964529,28014,766639,98437,916899,223329,820154,268442,746327,278009,828541,618475,334742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000882s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002341s ]