SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028690 LIMIT 1 [ RunTime:0.000553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028690 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8039,418163,489077,731931,11122,310678,517531,237131,719835,591623,869168,90649,1030731,753544,630678,320433,572792,322438,579031,966270,702026,847088,677438,228225,878172,287271,923992,407342,214893,161648,149908,842075,578901,10182,524426,680268,849263,49462,657467,465340,122443,207036,183722,312632,83669,285442,68661,931804,826111,839304,156560,1032401,946177,649878,1028755,1029274,113096,168209,118219,570521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]