SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505049 LIMIT 1 [ RunTime:0.006689s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505049 [ RunTime:0.014632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310371,484667,195149,736534,197348,341470,797352,217025,798909,225234,922938,889467,999800,858145,90725,391382,254558,684208,797406,58088,729538,960352,1017077,726828,398441,197069,952030,895999,199948,909895,74562,595736,114252,488464,344146,201030,289292,515714,190472,377098,980887,350891,662197,745335,75515,825929,989709,103157,123341,221791,168477,78076,959435,905517,256895,29527,941710,308081,683024,846294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002818s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002202s ]