SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000919s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410142 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410142 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149699,1029962,627991,507755,93106,431344,1029648,913925,719879,629082,1026882,21883,836389,954096,710008,65333,97445,150074,228757,268416,586253,599307,396448,448215,601453,765218,45751,864138,122102,295849,98044,728904,912780,602017,147817,252252,336554,349597,27462,530642,758919,32521,497145,613231,808589,213899,586337,936000,672520,759014,169975,1019261,994228,392805,463214,681371,70924,196367,302892,504343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]