SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036141 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036141 [ RunTime:0.003142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011213,971417,217307,633568,466675,706469,773759,338524,540384,407425,962042,265389,165063,34227,546109,981717,1017838,1042716,40004,845214,422326,790976,923758,362068,656747,78416,684819,1020237,184098,469080,97094,1011329,1027840,708432,881827,800069,870586,778523,359897,152770,954160,1033866,705000,273725,878286,578100,340134,671465,381558,248067,696355,368182,568717,434034,51663,89443,87445,994965,590709,952407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]