SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319901 LIMIT 1 [ RunTime:0.000647s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319901 [ RunTime:0.002071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295369,359655,572940,789674,392392,555320,646599,352451,106195,363050,75801,1023529,242833,166592,945330,19957,833083,941605,593202,755306,888587,922552,707662,230436,161686,763810,262951,637015,964950,698782,414448,810878,788258,824424,589853,499392,638427,677625,307733,569437,744653,388950,83501,193872,268174,24466,217016,545875,586973,617580,962206,649783,315761,367796,933372,1047650,952828,225571,443720,584062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]