SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48175 LIMIT 1 [ RunTime:0.001175s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48175 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562326,207270,841671,841744,954870,497540,905546,799588,842086,790166,116866,433394,541012,1019387,102284,799720,224500,194710,668215,206910,185376,25053,680247,348924,889725,823087,775330,270385,746220,640628,212236,938110,98406,831099,998836,729313,861239,27908,108448,820171,254798,737743,46325,10344,767951,207300,593813,979549,403858,989081,424079,559205,444293,1039362,402708,931727,344609,455584,801482,229587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]