SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439186 LIMIT 1 [ RunTime:0.002398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439186 [ RunTime:0.004199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617342,402781,439337,734454,1027512,573727,717416,626766,237392,291213,557918,339292,987442,125801,110702,10203,343354,300091,406504,618380,285629,788980,536983,692038,257387,1030047,414600,505304,169267,809676,352927,424875,176646,909587,441904,430034,721918,742389,573035,761366,899950,271098,82049,409769,289215,906535,418903,4024,943645,173634,250205,641648,402936,386274,90275,745673,885803,748923,726211,492431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]