SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681931 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681931 [ RunTime:0.003447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289165,740246,698374,619035,335884,649920,998420,690860,540091,664318,107052,988760,820443,168206,1039978,807440,162388,405522,707682,825040,27362,133821,891978,15436,951212,717008,646057,305574,800708,674031,254279,953367,625924,779312,767628,410193,355512,623908,456730,193274,482402,852634,552502,544821,245580,810725,996340,952625,776851,418653,589495,138122,512697,765799,77804,763865,760459,1021655,272205,736574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]