SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016683 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016683 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460823,555908,27795,111690,84487,630756,806441,737629,53233,29680,489771,220363,33505,152186,55243,435086,947730,211855,481752,847122,404090,714904,57546,955375,521471,620845,395658,656018,445556,962554,933230,522234,512570,758798,49370,807803,589621,479316,250426,491867,842027,883398,530286,10689,229685,499193,761824,313304,876364,477197,236624,149123,898532,938780,55831,790834,1024414,543512,219853,89747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003702s ]