SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511981 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511981 [ RunTime:0.001435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220940,997910,796683,110697,264285,163229,220805,716923,492892,1031794,484530,266185,392862,474971,494791,780655,539298,115396,546898,1041178,641172,378417,319201,1014471,126301,1027013,91042,597964,795173,976198,314866,628612,895403,490233,751752,716660,880679,53326,1034634,418203,774413,368653,788676,549945,513722,889586,435541,561261,336084,293644,800444,547167,742565,796991,445087,364501,113671,17632,368419,864373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]