SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418706 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418706 [ RunTime:0.002515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047446,997493,470003,100243,27685,368423,967311,965566,64902,36840,116117,441697,905590,168377,411414,783382,532654,683630,320240,471421,296293,980353,523125,861113,1028306,768363,682697,606185,403160,4308,103455,148744,158962,701408,90503,204969,541831,980200,146972,743330,574784,679663,796434,1032015,739215,466336,356271,543028,231934,405934,869612,375159,634069,142450,84433,263415,181434,811412,753903,403238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]