SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013271 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013271 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462721,234397,154987,234299,101543,245454,379633,266798,199184,175389,384081,229493,985863,963698,479373,190885,397904,136346,222917,492984,465570,545303,799907,582233,936811,736747,66693,797491,589502,192975,966841,469065,681733,159502,748239,868780,776850,949215,399648,468079,675097,608085,70509,849291,379864,301971,491280,606041,457875,828644,37391,702871,602237,317423,740249,756392,310336,113915,658324,694407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]