SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002036s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475542 LIMIT 1 [ RunTime:0.000551s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475542 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854361,856796,1009145,55829,611599,521772,335590,988065,437399,843511,505267,11203,327603,37686,844535,265464,488391,243433,491361,958580,468406,275848,487136,104654,1048155,44297,607310,170101,282470,406819,349818,252235,855822,917095,276773,662504,238804,501902,461315,293869,537722,623628,339807,113037,118126,474085,222666,147905,532957,60645,526655,475378,945108,635121,907932,234856,473489,751739,851852,471834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]