SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54181 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54181 [ RunTime:0.002446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858493,985705,662057,605283,645920,103881,83473,870185,359203,827519,710001,986551,657562,833423,710434,853872,58240,204836,203274,206922,858780,467003,857574,799962,351089,856491,924096,108163,714832,361923,988956,909955,451669,690841,61652,408659,780767,945187,276899,1013899,627706,32417,459959,348427,1021817,259937,616361,355965,256681,296168,577667,418522,960914,789429,117343,686036,275325,621895,762381,411956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]