SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581986 LIMIT 1 [ RunTime:0.002600s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581986 [ RunTime:0.004849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623412,423533,919825,476875,393613,722220,937379,855236,339216,534509,975812,137365,966862,1022732,154977,42536,172327,802713,365866,954015,481214,50823,1005823,701540,136755,692514,232920,903197,92623,494066,433538,374768,285159,956715,216055,425761,618291,1024443,73088,248459,951079,828451,832201,541295,903110,118383,680334,742178,1016778,660944,428108,819690,518337,623649,298678,180132,265669,378967,555114,861021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]