SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405120 LIMIT 1 [ RunTime:0.000738s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405120 [ RunTime:0.001409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604853,263380,962990,142210,246364,107933,507624,377084,798350,637847,815018,889791,195310,648114,864927,329198,431818,518165,542391,684867,419581,929892,655484,136828,788744,867462,653313,549081,573614,757600,470942,435508,339200,252279,137408,91050,240008,728177,466392,131946,408239,470219,638686,732486,726694,282627,623721,441222,1041079,780753,655515,748158,26980,346621,336060,371420,1036626,968134,1047468,465904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002510s ]