SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807380 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807380 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595883,645223,938519,890314,408425,440776,1026386,550725,168131,661027,310184,416879,907129,650389,674804,473393,431005,556839,395618,432718,701956,556444,466004,295614,64611,917153,108061,727413,405428,307359,434738,941635,125467,214049,1024809,344793,184966,804364,540714,639016,279927,904955,428735,84418,1025467,494507,898012,633748,595600,929551,676760,500539,568992,449287,248434,1016911,481003,770804,312178,168822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]