SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408602 LIMIT 1 [ RunTime:0.002134s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408602 [ RunTime:0.002989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721783,458518,610008,535925,169964,295555,364707,986183,208588,295088,178503,410132,497772,52181,500211,972804,649070,52698,169518,241432,192689,580501,364948,237553,363469,59885,958635,717814,590932,979990,303826,538310,474346,167231,568410,17518,821142,645050,270260,160739,1043912,357265,164874,456829,991603,277273,969232,733748,695596,855434,81340,199671,1030240,995794,814440,931442,556323,285197,772723,12410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]