SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484006 LIMIT 1 [ RunTime:0.002155s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484006 [ RunTime:0.002640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240243,700647,563889,268938,21106,560714,162754,691212,366434,173800,169102,740428,1041307,24551,956993,749281,179756,620485,536184,570880,1044081,995502,109523,1007977,257501,712330,311245,659778,739509,415315,719402,204434,258187,863978,1030912,385352,166375,988391,162857,504246,374301,809120,1022180,285914,55963,776200,55240,1009279,1011482,579291,83459,533615,717986,958036,376255,458249,464064,76351,354588,379064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]