SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418123 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418123 [ RunTime:0.003161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539441,239225,173480,602162,734117,974402,460826,938867,1019999,176344,725970,645007,81609,578659,760500,800955,263694,501809,460921,365256,822055,953841,96467,699601,322367,380157,952200,481821,81741,382650,738988,374890,178574,589988,104778,308736,574786,1001777,200911,789675,1047435,602441,1036398,146791,85983,944839,13146,64195,312249,411078,187683,729083,131923,991818,244454,673125,464477,304197,1022802,607666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418123 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418123 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002025s ]