SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510525 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510525 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421027,67863,333753,312545,1015553,396787,534510,727334,230058,337212,900036,950481,594854,589060,195438,581806,19591,895621,832646,693979,843411,665203,650387,526584,57759,979440,983569,742673,484564,457799,460201,931077,628497,890047,826607,545042,995917,317907,518600,676003,701621,749515,482022,189445,728629,471135,545235,331672,902835,821405,150606,621421,401923,796187,912988,938600,274678,175161,384048,431665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]