SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 83643 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 83643 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035378,429202,162028,37399,61032,417101,685238,1039595,660486,230541,177015,558163,558004,166721,64834,703785,370147,234655,966836,562410,766365,128573,756775,391622,681478,313335,394705,400352,541522,1017465,38469,109167,782192,871065,537440,814821,427905,619650,845525,143431,949222,1018775,786339,192550,646537,167744,137344,268880,313286,926449,1004257,1039993,53252,567274,358312,668604,878130,813327,995577,973656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 83643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 83643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]