SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048462 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048462 [ RunTime:0.004560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321240,945477,889459,1042421,988668,1029659,502995,953676,852255,65536,365322,261727,182438,990155,503183,118470,616574,79551,2357,488802,94204,53488,998733,743107,55791,180771,60261,300110,11307,832012,646894,841204,564088,764545,582247,251941,590203,61765,7054,120517,961250,129714,62394,412794,61605,775235,902914,50462,656023,603432,796866,836951,75048,786634,96290,58745,504540,429014,117094,496131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048462 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048462 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001740s ]