SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516844 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516844 [ RunTime:0.002544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458776,580325,866736,795097,753379,169424,448775,1030168,169817,75553,247180,418498,488754,498034,606065,153822,92805,332690,121133,287309,347413,936178,1518,382658,615236,219747,79058,92895,368165,301311,179233,599276,317486,413782,461035,49872,575592,84601,849656,526527,59192,614639,433957,492808,1032765,790127,271292,97536,1042085,32956,961298,677498,920053,159609,254044,210746,1026302,1044964,667413,443656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]