SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016618 LIMIT 1 [ RunTime:0.001110s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016618 [ RunTime:0.005457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630008,659318,524843,342869,296195,611957,484108,938963,853948,280312,452454,423973,213648,635349,712503,623947,482528,113928,823142,21891,285915,17483,902847,702668,817998,315201,186909,372324,1041295,702541,507904,521954,953370,798094,369342,33490,820157,860706,878847,512407,830285,291604,540074,636499,84162,122225,95297,332568,513792,360804,151570,281719,147072,395379,648682,559887,755733,714042,911516,413089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]