SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190809 LIMIT 1 [ RunTime:0.002380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190809 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192974,474535,53958,1038559,814669,355218,192344,784711,53968,122795,541720,121918,130980,1036543,106350,847441,506061,613388,1031528,691538,193653,18780,922097,682615,927143,1040875,420271,779567,674773,591768,204560,481543,757955,769198,607987,289934,896991,449193,97683,905465,371262,859553,771459,9139,264643,515672,52636,997099,1018772,321544,533473,850934,60984,811647,2372,786402,616980,618948,77672,67325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]