SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415131 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415131 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193822,187741,821631,1029781,713236,199743,262379,811669,235998,377614,57341,1035222,307042,421865,119455,837365,971031,467455,967237,24590,658096,997910,711409,488899,407382,52372,1009812,321009,612367,41669,649356,284045,640090,968594,810194,991696,651056,594364,1038139,972926,392018,292429,265169,589382,496345,297570,91236,212053,743563,386353,249885,114997,282055,423085,872467,597109,791282,985511,153764,91946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]