SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 352807 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 352807 [ RunTime:0.002175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593863,778049,1020943,362064,589140,648153,161116,329161,797925,821811,826231,540340,509030,997295,13166,14843,835427,518600,396659,621288,601893,696507,606357,42254,18901,128452,587602,939045,518214,476640,780863,849846,105945,1006430,882163,997724,229214,187653,634678,97871,855378,1033261,622641,1016177,523509,403664,588536,206948,1033454,567467,507102,518342,359755,639545,939884,829078,374653,882454,109956,752991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 352807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 352807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]