SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002019s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024013 LIMIT 1 [ RunTime:0.001398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024013 [ RunTime:0.002636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94432,339166,127306,75494,944243,747040,43273,912800,198391,810625,691480,407419,35222,523342,899641,700000,427655,569717,536425,793364,227763,590156,184736,44563,169674,547102,760134,474009,74435,18212,948579,214103,492810,859620,1031846,751448,873071,567816,828672,381157,5669,953273,811337,455503,1042989,982954,277664,733832,791121,783747,633421,316326,821441,212346,269510,625909,220832,295568,902369,545670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001203s ]