SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440098 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440098 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21974,844467,83555,393708,968749,973963,599853,226540,433327,677358,382617,527273,220855,451924,652140,297370,1037741,959531,277045,123463,119840,893299,930544,138005,294067,509097,92872,547769,781629,555712,566194,1006253,923289,787450,368616,455739,1045608,925503,740032,216488,446249,679141,1018494,566542,712049,385694,411569,466671,795781,106655,682491,666741,69150,578679,587432,294484,375793,232267,218741,618787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000849s ]