SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421060 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421060 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405922,154869,773077,158263,116738,860603,700701,186751,562239,421170,437490,154188,642535,197382,664363,639767,896253,609291,79136,380597,661619,278515,393902,508092,523133,859813,373885,452684,517730,785393,774560,28149,604705,887807,128491,704595,468726,701217,270788,13508,596938,477147,408294,364049,13337,110070,387146,491750,77800,773041,496086,753803,243260,721167,184781,729241,950642,473948,319727,381599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]