SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017154 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017154 [ RunTime:0.002488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271568,268838,271999,931254,742760,595560,647366,684242,708382,834400,67717,175859,291930,960958,725140,841506,1023924,994837,736051,92103,851119,921547,741318,330676,374603,409843,171601,672759,269711,1047023,565722,688540,836249,542876,754617,681205,509466,559541,649532,559119,858870,8796,24829,138835,808727,474662,269984,865161,441041,990816,723922,445831,361153,340147,1023899,1002011,46329,308445,20457,426876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017154 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017154 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000913s ]