SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001503 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001503 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031359,505025,4055,188897,436137,1041084,333684,341864,181896,675191,616848,406706,313084,690541,954653,205601,189450,658828,587433,330879,78350,708484,889183,372257,168184,641471,692084,445863,216265,925675,934093,994104,439104,565355,207864,330592,718369,957002,410546,377595,470954,609939,771476,781952,484278,139704,1046911,152677,337710,354685,974199,33374,780281,724723,609264,254197,49669,861259,669319,502386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]