SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507540 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507540 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178206,585720,146880,35065,362739,107873,650423,204757,704986,122216,587625,939199,920788,459102,30220,539528,490389,319040,241190,718511,451349,139718,65168,636202,189573,496330,986933,1028502,807777,828853,397787,354866,329427,555810,229763,213850,469937,506275,860885,866273,182535,467875,608177,538503,976415,444960,1042919,213392,255479,668854,573288,986744,1011840,178639,613676,847853,353854,754376,330427,648672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]