SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428191 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428191 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439080,204464,20157,10735,118600,922517,311380,97258,364597,1008938,913696,726277,625843,623618,953029,695840,840226,490076,49106,766643,94322,141457,953522,581453,1008109,665954,265801,757353,815760,862016,291992,489652,605799,688546,349649,463033,411871,446911,806336,1001791,909221,775542,106117,666846,947157,651479,867212,651158,824676,423028,317226,660335,334089,648497,548723,776908,996951,27855,236791,712410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002833s ]