SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003546s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018428 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018428 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849978,337784,360576,692803,1028782,851557,302602,299866,204899,573393,459489,180691,69013,853664,307070,337754,19351,221122,569524,386463,524288,234906,12557,558632,485762,85482,308954,197238,609614,676351,710358,12353,34812,140107,467367,400207,882748,848586,349052,764133,1045375,1003311,537689,476190,37472,487978,551889,346189,401735,193396,352095,140606,549427,825270,210361,695624,44716,126459,246960,841888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000815s ]