SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194117 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194117 [ RunTime:0.002513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465710,1022286,897760,555973,48000,831136,411384,472911,681410,672589,265379,890440,1007216,383147,359911,377941,277626,985948,329934,256281,888549,844997,358162,396634,12051,259634,800818,809944,547144,851660,418123,607769,681353,494598,854115,96222,409605,717868,930535,543708,536106,936361,504435,949393,1033616,848776,48462,240244,374397,604115,702165,146996,210091,718214,154685,522754,438545,33247,610037,819503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]