SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526171 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526171 [ RunTime:0.002794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280773,394198,615488,989165,1004027,318340,697799,415138,560371,477086,341090,985645,381044,99692,975772,234778,63847,327655,504564,232025,876844,824144,635551,595968,78312,584866,417067,665379,620968,707517,951987,110869,223980,542528,22968,645540,273027,932393,834910,860382,408607,629425,514245,5859,565823,400160,205738,565836,899585,304772,775349,581747,119177,207211,649005,4133,586310,918571,148820,1002110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000834s ]