SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516593 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516593 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997402,874321,423583,816551,1003790,198343,674752,1007460,32912,67816,331963,71776,928347,443683,835478,577602,992133,547194,688682,103838,955909,242407,576400,210229,269162,881610,823260,347435,547093,849712,414683,530751,751333,733973,879279,479756,977850,303031,715466,877471,451940,776434,1007589,535057,630703,699366,380958,140723,626277,1023740,329099,641003,110772,417779,316287,10680,540764,185737,603072,922986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]