SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495246 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495246 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312002,200908,231614,298975,282918,521350,493818,139279,922397,802039,130827,1040941,490753,23425,615774,864075,892778,866193,705937,643566,104539,311921,527454,192235,1000050,50095,603091,251793,448413,199743,780229,33066,308236,640965,396559,374839,1041244,856524,633850,404147,319049,250674,931993,723221,630930,810292,561170,936628,703185,668097,633291,1031215,688831,958940,283449,300007,323793,127700,634534,559787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]