SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503843 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503843 [ RunTime:0.002468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736146,894109,25063,95967,651731,191423,1014143,770942,262772,869027,885626,796395,485737,960512,436352,137034,926622,346039,569795,204998,952436,360026,392400,304087,949159,817124,186927,322241,782213,352547,450821,406106,686491,505975,256030,956467,699886,115163,788448,1010409,1012048,269976,692686,1012988,324116,5199,115644,861807,794074,864794,246179,74055,280252,583506,890896,685004,34773,722570,187905,660233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]