SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482406 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482406 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009469,196258,365961,434706,766833,962093,516044,83319,749610,281228,445006,691890,1022460,817344,721580,56990,399156,290032,996363,20014,386621,952626,171397,46129,722702,659758,1024116,28964,511524,58056,190143,819137,137943,718877,126856,585184,57747,873370,9796,177418,397900,514656,594692,747738,528664,760329,928795,995384,466102,938466,176824,496482,947711,557990,622747,830391,893055,918269,162837,158077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004011s ]