SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038099 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038099 [ RunTime:0.002233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291632,213187,461282,65235,144916,288919,586330,789768,555915,386160,525638,630535,124286,816362,213687,381882,846120,110145,661963,136293,536439,44888,610912,842880,529457,615400,401500,972432,147718,215502,57792,797659,796960,387433,51229,729370,231370,831332,243223,655911,545054,706599,355483,363871,199446,242875,587655,889987,376485,293608,923710,438441,825506,744657,997939,919409,353352,964086,742128,38285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]