SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020787 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020787 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130292,746871,851778,699736,880983,1023976,625536,539358,32152,863910,704308,1022814,617011,860847,125055,99646,995719,213036,115142,530689,359787,518016,935920,623263,79615,367138,953965,385786,263694,10065,999832,314357,317904,918185,183818,616992,607326,502613,97261,881751,576713,309464,302316,488459,535780,139771,484447,355056,908801,147209,427620,714513,706951,419431,641981,386624,690193,740424,709344,292946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]