SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593409 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593409 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805842,545585,861859,682728,219290,674604,186206,37656,607894,175370,361077,504987,482803,357539,857029,82904,86785,679720,1033361,713498,567495,982615,193519,935261,252536,864649,58614,125944,140339,566250,84259,852172,217291,84424,764669,721748,989930,741287,1011591,70398,853140,423302,134323,815683,638337,136106,235856,768524,473999,733069,221303,965213,714131,359719,644925,299510,969924,115270,459791,821447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002898s ]